判断是否是 null，判断是否在两个数之间

用 IS NULL（ IS NOT NULL）判断是否是 null, 用 BETWEEN 判断一个数是否在一个范围，用表格展示

SQL

|
SELECT
  http_method IS NULL as "判断是否是 null",
  http_method IS NOT NULL as "判断是否是 null(方法2)",
  delta_data_size BETWEEN 2000
  AND 5000 as "是否在 2000-5000 之间"

SQL查询结果样例：

样例图片